Vivo Sales Analytics
Intro
As part of Vivo Data Analytics screening, I was handed an simulated Excel Data and was challenged to provide Sales Insight, the Data consist of 2 main tables, first is a time series of April Sales, the second is sales summary of multiple products through different distributed channels.
A look at the data after being processed for our analysis
April TimeSeries
First Quarter
April Analysis
As we can see from the chart bellow, sales was higher at the beginning of April and during the last 2 days. FF Model accounted for 38% of Total Sales
First Quarter
The Bar-Graph bellow shows the total quantity sold for each Model in the first Quarter, Febraury Had a huge spike in the sold quantities which positively correlates with Sales-Through of 30 per Model.